<!DOCTYPE html>
<html>
<head>
  <meta charset="utf-8">
  

  
  <title>一起学Excel</title>
  <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">
  <meta property="og:type" content="website">
<meta property="og:title" content="一起学Excel">
<meta property="og:url" content="https://lecoder.gitee.io/study-excel/page/25/index.html">
<meta property="og:site_name" content="一起学Excel">
<meta property="og:locale" content="zh_CN">
<meta property="article:author" content="lijile">
<meta name="twitter:card" content="summary">
  
  
    <link rel="icon" href="/favicon.png">
  
  
    <link href="//fonts.googleapis.com/css?family=Source+Code+Pro" rel="stylesheet" type="text/css">
  
  
<link rel="stylesheet" href="/study-excel/css/style.css">

<meta name="generator" content="Hexo 6.3.0"></head>

<body>
  <div id="container">
    <div id="wrap">
      <header id="header">
  <div id="banner"></div>
  <div id="header-outer" class="outer">
    <div id="header-title" class="inner">
      <h1 id="logo-wrap">
        <a href="/study-excel/" id="logo">一起学Excel</a>
      </h1>
      
    </div>
    <div id="header-inner" class="inner">
      <nav id="main-nav">
        <a id="main-nav-toggle" class="nav-icon"></a>
        
          <a class="main-nav-link" href="/study-excel/">Home</a>
        
          <a class="main-nav-link" href="/study-excel/archives">Archives</a>
        
      </nav>
      <nav id="sub-nav">
        
        <a id="nav-search-btn" class="nav-icon" title="搜索"></a>
      </nav>
      <div id="search-form-wrap">
        <form action="//google.com/search" method="get" accept-charset="UTF-8" class="search-form"><input type="search" name="q" class="search-form-input" placeholder="Search"><button type="submit" class="search-form-submit">&#xF002;</button><input type="hidden" name="sitesearch" value="https://lecoder.gitee.io/study-excel"></form>
      </div>
    </div>
  </div>
</header>
      <div class="outer">
        <section id="main">
  
    <article id="post-excel-f-dist-rt-function" class="article article-type-post" itemscope itemprop="blogPost">
  <div class="article-meta">
    <a href="/study-excel/excel-f-dist-rt-function/" class="article-date">
  <time datetime="2022-11-23T08:00:51.238Z" itemprop="datePublished">2022-11-23</time>
</a>
    
  <div class="article-category">
    <a class="article-category-link" href="/study-excel/categories/%E5%87%BD%E6%95%B0/">函数</a>
  </div>

  </div>
  <div class="article-inner">
    
    
      <header class="article-header">
        
  
    <h1 itemprop="name">
      <a class="article-title" href="/study-excel/excel-f-dist-rt-function/">Excel F.DIST.RT 函数</a>
    </h1>
  

      </header>
    
    <div class="article-entry" itemprop="articleBody">
      
        <p>F.DIST.RT 函数返回右尾F概率分布。</p>
<h2 id="适用版本"><a href="#适用版本" class="headerlink" title="适用版本"></a>适用版本</h2><p>Excel 2010+</p>
<h2 id="说明"><a href="#说明" class="headerlink" title="说明"></a>说明</h2><p>F.DIST.RT 函数返回右尾F概率分布。</p>
<h2 id="返回值"><a href="#返回值" class="headerlink" title="返回值"></a>返回值</h2><p>右尾F概率分布。</p>
<h2 id="语法"><a href="#语法" class="headerlink" title="语法"></a>语法</h2><figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=F.DIST.RT(x,deg_freedom1,deg_freedom2)</span><br></pre></td></tr></table></figure>

<h2 id="参数"><a href="#参数" class="headerlink" title="参数"></a>参数</h2><ul>
<li>X 必需。 用来计算函数的值。</li>
<li>Deg_freedom1 必需。 分子自由度。</li>
<li>Deg_freedom2 必需。 分母自由度。</li>
</ul>
<h2 id="实例"><a href="#实例" class="headerlink" title="实例"></a>实例</h2><p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_3e5e88b67e370733192bbe3b48e30196.png"></p>
<h2 id="可能出现的错误"><a href="#可能出现的错误" class="headerlink" title="可能出现的错误"></a>可能出现的错误</h2><ul>
<li>#NUM!<ul>
<li>如果提供的参数 x 是负数；</li>
<li>如果提供的参数 deg_freedom1 或者 deg_freedom2 ＜ 1。</li>
</ul>
</li>
<li>#VALUE!<ul>
<li>如果提供的任意参数不是数值类型。</li>
</ul>
</li>
</ul>
<h2 id="其他"><a href="#其他" class="headerlink" title="其他"></a>其他</h2><p>更多信息及示例请参考<a target="_blank" rel="noopener" href="https://support.office.com/zh-cn/article/F-DIST-RT-%E5%87%BD%E6%95%B0-d74cbb00-6017-4ac9-b7d7-6049badc0520">微软Office网站</a>。</p>

      
    </div>
    <footer class="article-footer">
      <a data-url="https://lecoder.gitee.io/study-excel/excel-f-dist-rt-function/" data-id="clatcwgqh01ayxcq6a01lcazp" class="article-share-link">Share</a>
      
      
    </footer>
  </div>
  
</article>


  
    <article id="post-excel-f-inv-function" class="article article-type-post" itemscope itemprop="blogPost">
  <div class="article-meta">
    <a href="/study-excel/excel-f-inv-function/" class="article-date">
  <time datetime="2022-11-23T08:00:51.238Z" itemprop="datePublished">2022-11-23</time>
</a>
    
  <div class="article-category">
    <a class="article-category-link" href="/study-excel/categories/%E5%87%BD%E6%95%B0/">函数</a>
  </div>

  </div>
  <div class="article-inner">
    
    
      <header class="article-header">
        
  
    <h1 itemprop="name">
      <a class="article-title" href="/study-excel/excel-f-inv-function/">Excel F.INV 函数</a>
    </h1>
  

      </header>
    
    <div class="article-entry" itemprop="articleBody">
      
        <p>F.INV 函数返回F概率分布函数的反函数。</p>
<h2 id="适用版本"><a href="#适用版本" class="headerlink" title="适用版本"></a>适用版本</h2><p>Excel 2010+</p>
<h2 id="说明"><a href="#说明" class="headerlink" title="说明"></a>说明</h2><p>F.INV 函数返回F概率分布函数的反函数。</p>
<h2 id="返回值"><a href="#返回值" class="headerlink" title="返回值"></a>返回值</h2><p>F概率分布函数的反函数。</p>
<h2 id="语法"><a href="#语法" class="headerlink" title="语法"></a>语法</h2><figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=F.INV(probability,deg_freedom1,deg_freedom2)</span><br></pre></td></tr></table></figure>

<h2 id="参数"><a href="#参数" class="headerlink" title="参数"></a>参数</h2><ul>
<li>Probability 必需。 F 累积分布函数的概率值。。</li>
<li>Deg_freedom1 必需。 分子自由度。</li>
<li>Deg_freedom2 必需。 分母自由度。</li>
</ul>
<h2 id="实例"><a href="#实例" class="headerlink" title="实例"></a>实例</h2><p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_4f14037f50f2a48f93ee8e4ccfca4d66.png"></p>
<h2 id="可能出现的错误"><a href="#可能出现的错误" class="headerlink" title="可能出现的错误"></a>可能出现的错误</h2><ul>
<li>#NUM!<ul>
<li>如果提供的参数 probability ＜0或者 ≥ 1；</li>
<li>如果提供的参数 deg_freedom1 或者 deg_freedom2 ＜ 1。</li>
</ul>
</li>
<li>#VALUE!<ul>
<li>如果提供的任意参数不是数值类型。</li>
</ul>
</li>
</ul>
<h2 id="其他"><a href="#其他" class="headerlink" title="其他"></a>其他</h2><p>更多信息及示例请参考<a target="_blank" rel="noopener" href="https://support.office.com/zh-cn/article/F-INV-%E5%87%BD%E6%95%B0-0dda0cf9-4ea0-42fd-8c3c-417a1ff30dbe">微软Office网站</a>。</p>

      
    </div>
    <footer class="article-footer">
      <a data-url="https://lecoder.gitee.io/study-excel/excel-f-inv-function/" data-id="clatcwgqj01b0xcq60gakd0sf" class="article-share-link">Share</a>
      
      
    </footer>
  </div>
  
</article>


  
    <article id="post-excel-f-test-function" class="article article-type-post" itemscope itemprop="blogPost">
  <div class="article-meta">
    <a href="/study-excel/excel-f-test-function/" class="article-date">
  <time datetime="2022-11-23T08:00:51.238Z" itemprop="datePublished">2022-11-23</time>
</a>
    
  <div class="article-category">
    <a class="article-category-link" href="/study-excel/categories/%E5%87%BD%E6%95%B0/">函数</a>
  </div>

  </div>
  <div class="article-inner">
    
    
      <header class="article-header">
        
  
    <h1 itemprop="name">
      <a class="article-title" href="/study-excel/excel-f-test-function/">Excel F.TEST 函数</a>
    </h1>
  

      </header>
    
    <div class="article-entry" itemprop="articleBody">
      
        <p>F.TEST 函数返回F检验结果，即当两组数据的方差无明显差异时的双尾概率。</p>
<h2 id="适用版本"><a href="#适用版本" class="headerlink" title="适用版本"></a>适用版本</h2><p>Excel 2010+</p>
<h2 id="说明"><a href="#说明" class="headerlink" title="说明"></a>说明</h2><p>F.TEST 函数返回F检验结果，即当两组数据的方差无明显差异时的双尾概率。</p>
<h2 id="返回值"><a href="#返回值" class="headerlink" title="返回值"></a>返回值</h2><p>F检验结果。</p>
<h2 id="语法"><a href="#语法" class="headerlink" title="语法"></a>语法</h2><figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=F.TEST(array1,array2)</span><br></pre></td></tr></table></figure>

<h2 id="参数"><a href="#参数" class="headerlink" title="参数"></a>参数</h2><ul>
<li>Array1 必需。 第一个数据区域。</li>
<li>Array2 必需。 第二个数据区域。</li>
</ul>
<h2 id="要点"><a href="#要点" class="headerlink" title="要点"></a>要点</h2><ul>
<li>参数可以是数字，或者是包含数字的名称、数组或引用。</li>
<li>如果数组或引用参数包含文本、逻辑值或空白单元格，则这些值将被忽略。</li>
</ul>
<h2 id="实例"><a href="#实例" class="headerlink" title="实例"></a>实例</h2><p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_28d1b264d04ffd629a616e4fe313a49c.png"></p>
<h2 id="可能出现的错误"><a href="#可能出现的错误" class="headerlink" title="可能出现的错误"></a>可能出现的错误</h2><ul>
<li>#DIV&#x2F;0!<ul>
<li>如果提供的参数两组数据的元素少于2；</li>
<li>如果提供的参数两组数据方差等于零。</li>
</ul>
</li>
</ul>
<h2 id="其他"><a href="#其他" class="headerlink" title="其他"></a>其他</h2><p>更多信息及示例请参考<a target="_blank" rel="noopener" href="https://support.office.com/zh-cn/article/F-TEST-%E5%87%BD%E6%95%B0-100a59e7-4108-46f8-8443-78ffacb6c0a7">微软Office网站</a>。</p>

      
    </div>
    <footer class="article-footer">
      <a data-url="https://lecoder.gitee.io/study-excel/excel-f-test-function/" data-id="clatcwgqm01b4xcq64ihn2gnm" class="article-share-link">Share</a>
      
      
    </footer>
  </div>
  
</article>


  
    <article id="post-excel-f-inv-rt-function" class="article article-type-post" itemscope itemprop="blogPost">
  <div class="article-meta">
    <a href="/study-excel/excel-f-inv-rt-function/" class="article-date">
  <time datetime="2022-11-23T08:00:51.222Z" itemprop="datePublished">2022-11-23</time>
</a>
    
  <div class="article-category">
    <a class="article-category-link" href="/study-excel/categories/%E5%87%BD%E6%95%B0/">函数</a>
  </div>

  </div>
  <div class="article-inner">
    
    
      <header class="article-header">
        
  
    <h1 itemprop="name">
      <a class="article-title" href="/study-excel/excel-f-inv-rt-function/">Excel F.INV.RT 函数</a>
    </h1>
  

      </header>
    
    <div class="article-entry" itemprop="articleBody">
      
        <p>F.INV.RT 函数返回右尾F概率分布函数的反函数。</p>
<h2 id="适用版本"><a href="#适用版本" class="headerlink" title="适用版本"></a>适用版本</h2><p>Excel 2010+</p>
<h2 id="说明"><a href="#说明" class="headerlink" title="说明"></a>说明</h2><p>F.INV.RT 函数返回右尾F概率分布函数的反函数。</p>
<h2 id="返回值"><a href="#返回值" class="headerlink" title="返回值"></a>返回值</h2><p>右尾F概率分布函数的反函数。</p>
<h2 id="语法"><a href="#语法" class="headerlink" title="语法"></a>语法</h2><figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=F.INV.RT(probability,deg_freedom1,deg_freedom2)</span><br></pre></td></tr></table></figure>

<h2 id="参数"><a href="#参数" class="headerlink" title="参数"></a>参数</h2><ul>
<li>Probability 必需。 F 累积分布函数的概率值。。</li>
<li>Deg_freedom1 必需。 分子自由度。</li>
<li>Deg_freedom2 必需。 分母自由度。</li>
</ul>
<h2 id="实例"><a href="#实例" class="headerlink" title="实例"></a>实例</h2><p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_b3cdb4c212d8167bf7870fbd1ee098b2.png"></p>
<h2 id="可能出现的错误"><a href="#可能出现的错误" class="headerlink" title="可能出现的错误"></a>可能出现的错误</h2><ul>
<li>#NUM!<ul>
<li>如果提供的参数 probability ＜0或者 ≥ 1；</li>
<li>如果提供的参数 deg_freedom1 或者 deg_freedom2 ＜ 1。</li>
</ul>
</li>
<li>#VALUE!<ul>
<li>如果提供的任意参数不是数值类型。</li>
</ul>
</li>
</ul>
<h2 id="其他"><a href="#其他" class="headerlink" title="其他"></a>其他</h2><p>更多信息及示例请参考<a target="_blank" rel="noopener" href="https://support.office.com/zh-cn/article/F-INV-RT-%E5%87%BD%E6%95%B0-d371aa8f-b0b1-40ef-9cc2-496f0693ac00">微软Office网站</a>。</p>

      
    </div>
    <footer class="article-footer">
      <a data-url="https://lecoder.gitee.io/study-excel/excel-f-inv-rt-function/" data-id="clatcwgql01b2xcq68yufg147" class="article-share-link">Share</a>
      
      
    </footer>
  </div>
  
</article>


  
    <article id="post-excel-fisher-function" class="article article-type-post" itemscope itemprop="blogPost">
  <div class="article-meta">
    <a href="/study-excel/excel-fisher-function/" class="article-date">
  <time datetime="2022-11-23T08:00:51.222Z" itemprop="datePublished">2022-11-23</time>
</a>
    
  <div class="article-category">
    <a class="article-category-link" href="/study-excel/categories/%E5%87%BD%E6%95%B0/">函数</a>
  </div>

  </div>
  <div class="article-inner">
    
    
      <header class="article-header">
        
  
    <h1 itemprop="name">
      <a class="article-title" href="/study-excel/excel-fisher-function/">Excel FISHER 函数</a>
    </h1>
  

      </header>
    
    <div class="article-entry" itemprop="articleBody">
      
        <p>FISHER 函数返回一个数值的Fisher变换值。</p>
<h2 id="适用版本"><a href="#适用版本" class="headerlink" title="适用版本"></a>适用版本</h2><p>Excel 2003+</p>
<h2 id="说明"><a href="#说明" class="headerlink" title="说明"></a>说明</h2><p>FISHER 函数返回一个数值的Fisher变换值。</p>
<h2 id="返回值"><a href="#返回值" class="headerlink" title="返回值"></a>返回值</h2><p>FISHER变换值。</p>
<h2 id="语法"><a href="#语法" class="headerlink" title="语法"></a>语法</h2><figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=FISHER(x)</span><br></pre></td></tr></table></figure>

<h2 id="参数"><a href="#参数" class="headerlink" title="参数"></a>参数</h2><ul>
<li>X 必需。 需要对其进行变换的数值。</li>
</ul>
<h2 id="实例"><a href="#实例" class="headerlink" title="实例"></a>实例</h2><p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_c1b979fd24ab6080de283229eeb38949.png"></p>
<h2 id="可能出现的错误"><a href="#可能出现的错误" class="headerlink" title="可能出现的错误"></a>可能出现的错误</h2><ul>
<li>#NUM!<ul>
<li>如果提供的参数 x ≤ -1 或者 ≥ 1；</li>
</ul>
</li>
<li>#VALUE!<ul>
<li>如果提供的参数 x 不是数值类型。</li>
</ul>
</li>
</ul>
<h2 id="其他"><a href="#其他" class="headerlink" title="其他"></a>其他</h2><p>更多信息及示例请参考<a target="_blank" rel="noopener" href="https://support.office.com/zh-cn/article/FISHER-%E5%87%BD%E6%95%B0-d656523c-5076-4f95-b87b-7741bf236c69">微软Office网站</a>。</p>

      
    </div>
    <footer class="article-footer">
      <a data-url="https://lecoder.gitee.io/study-excel/excel-fisher-function/" data-id="clatcwgqs01baxcq6g36u2tt3" class="article-share-link">Share</a>
      
      
    </footer>
  </div>
  
</article>


  
    <article id="post-excel-fisherinv-function" class="article article-type-post" itemscope itemprop="blogPost">
  <div class="article-meta">
    <a href="/study-excel/excel-fisherinv-function/" class="article-date">
  <time datetime="2022-11-23T08:00:51.222Z" itemprop="datePublished">2022-11-23</time>
</a>
    
  <div class="article-category">
    <a class="article-category-link" href="/study-excel/categories/%E5%87%BD%E6%95%B0/">函数</a>
  </div>

  </div>
  <div class="article-inner">
    
    
      <header class="article-header">
        
  
    <h1 itemprop="name">
      <a class="article-title" href="/study-excel/excel-fisherinv-function/">Excel FISHERINV 函数</a>
    </h1>
  

      </header>
    
    <div class="article-entry" itemprop="articleBody">
      
        <p>FISHERINV 函数返回一个数值的Fisher逆变换值。</p>
<h2 id="适用版本"><a href="#适用版本" class="headerlink" title="适用版本"></a>适用版本</h2><p>Excel 2003+</p>
<h2 id="说明"><a href="#说明" class="headerlink" title="说明"></a>说明</h2><p>FISHERINV 函数返回一个数值的Fisher逆变换值。</p>
<h2 id="返回值"><a href="#返回值" class="headerlink" title="返回值"></a>返回值</h2><p>FISHER逆变换值。</p>
<h2 id="语法"><a href="#语法" class="headerlink" title="语法"></a>语法</h2><figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=FISHERINV(y)</span><br></pre></td></tr></table></figure>

<h2 id="参数"><a href="#参数" class="headerlink" title="参数"></a>参数</h2><ul>
<li>Y 必需。 需要对其进行逆变换的数值。</li>
</ul>
<h2 id="实例"><a href="#实例" class="headerlink" title="实例"></a>实例</h2><p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_d759fa2956d43c18c434d2357e6b2159.png"></p>
<h2 id="可能出现的错误"><a href="#可能出现的错误" class="headerlink" title="可能出现的错误"></a>可能出现的错误</h2><ul>
<li>#VALUE!<ul>
<li>如果提供的参数 y 不是数值类型。</li>
</ul>
</li>
</ul>
<h2 id="其他"><a href="#其他" class="headerlink" title="其他"></a>其他</h2><p>更多信息及示例请参考<a target="_blank" rel="noopener" href="https://support.office.com/zh-cn/article/FISHERINV-%E5%87%BD%E6%95%B0-62504b39-415a-4284-a285-19c8e82f86bb">微软Office网站</a>。</p>

      
    </div>
    <footer class="article-footer">
      <a data-url="https://lecoder.gitee.io/study-excel/excel-fisherinv-function/" data-id="clatcwgqt01bcxcq66r7uf699" class="article-share-link">Share</a>
      
      
    </footer>
  </div>
  
</article>


  
    <article id="post-excel-forecast-ets-function" class="article article-type-post" itemscope itemprop="blogPost">
  <div class="article-meta">
    <a href="/study-excel/excel-forecast-ets-function/" class="article-date">
  <time datetime="2022-11-23T08:00:51.222Z" itemprop="datePublished">2022-11-23</time>
</a>
    
  <div class="article-category">
    <a class="article-category-link" href="/study-excel/categories/%E5%87%BD%E6%95%B0/">函数</a>
  </div>

  </div>
  <div class="article-inner">
    
    
      <header class="article-header">
        
  
    <h1 itemprop="name">
      <a class="article-title" href="/study-excel/excel-forecast-ets-function/">Excel FORECAST.ETS 函数</a>
    </h1>
  

      </header>
    
    <div class="article-entry" itemprop="articleBody">
      
        <p>FORECAST.ETS 函数根据已有的值，使用指数平滑算法预测未来值。</p>
<h2 id="适用版本"><a href="#适用版本" class="headerlink" title="适用版本"></a>适用版本</h2><p>Excel 2016+</p>
<h2 id="说明"><a href="#说明" class="headerlink" title="说明"></a>说明</h2><p>FORECAST.ETS 函数根据已有的值预测未来值。使用指数平滑算法预测未来值。</p>
<h2 id="返回值"><a href="#返回值" class="headerlink" title="返回值"></a>返回值</h2><p>未来值。</p>
<h2 id="语法"><a href="#语法" class="headerlink" title="语法"></a>语法</h2><figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=FORECAST.ETS( target_date, values, timeline, [seasonality], [datacompletion], [aggregation] )</span><br><span class="line">=FORECAST.ETS( 目标值日期,历史值, 历史日期, [季节性], [遗漏数据补充方式],[相同数据计算方式] )</span><br></pre></td></tr></table></figure>

<h2 id="参数"><a href="#参数" class="headerlink" title="参数"></a>参数</h2><ul>
<li>Target_date（必须）：一个需要预测与之对应的值的目标日期（或时间）。</li>
<li>Values （必须）：一组根据其预测未来值的历史值。</li>
<li>Timeline（必须）：与历史值相对应的一组日期（或时间）系列。<ul>
<li>历史日期（或时间）系列的长度必须与历史值一致；</li>
<li>系列中，每一个历史日期（或时间）之间的间隔必须相同；</li>
<li>系列中，历史日期（或时间）顺序可以是随机的。</li>
</ul>
</li>
<li>Seasonality（可选）：指示数据的季节性质的一个参数。<ul>
<li>0：数据无季节性质，使用线性算法预测；</li>
<li>1或省略：自动计算数据的季节性，并使用正整数步长作为季节长度；</li>
<li>≥2并≤8760的正整数：使用该数字作为季节长度。</li>
</ul>
</li>
<li>Data completion（可选）：指示日期（或时间）系列中遗漏数据的补充方式的参数。<ul>
<li>0：遗漏的数据计算为零；</li>
<li>1或省略：遗漏数据两侧数据的平均值作为该遗漏数据的值。</li>
</ul>
</li>
<li>Aggregation（可选）：指示具有相同日期（或时间）的数据的计算方式。<ul>
<li>1或省略：平均值；</li>
<li>2：计数；</li>
<li>3：计算（非空值）；</li>
<li>4：最大值；</li>
<li>5：中位数；</li>
<li>6：最小值；</li>
<li>7：求和。</li>
</ul>
</li>
</ul>
<h2 id="实例"><a href="#实例" class="headerlink" title="实例"></a>实例</h2><p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_813885d0a8592ef1ed1d80fbf990f489.png"></p>
<h2 id="可能出现的错误"><a href="#可能出现的错误" class="headerlink" title="可能出现的错误"></a>可能出现的错误</h2><ul>
<li>#N&#x2F;A!<ul>
<li>如果提供的已知日期（或时间）系列与历史值系列长度不一致时；</li>
</ul>
</li>
<li>#NUM!<ul>
<li>如果提供日期（或时间）系列不具有前后一致的步长时；</li>
<li>如果提供的“季节性”参数不在允许的范围内时；</li>
<li>如果提供的“遗漏数据补充方式”参数不等于0或1时；</li>
<li>如果提供的“相同数据计算方式”参数不等于1-7的任意一个数字时；</li>
</ul>
</li>
<li>#VALUE!<ul>
<li>如果提供的“季节性”、“遗漏数据补充方式”或“相同数据计算方式”中任意一个或多个不是数字时。</li>
</ul>
</li>
</ul>
<h2 id="其他"><a href="#其他" class="headerlink" title="其他"></a>其他</h2><p>更多信息及示例请参考<a target="_blank" rel="noopener" href="https://support.office.com/zh-cn/article/FORECAST-ETS-%e5%87%bd%e6%95%b0-15389b8b-677e-4fbd-bd95-21d464333f41?ui=zh-CN&rs=zh-CN&ad=CN">微软Office网站</a>。</p>

      
    </div>
    <footer class="article-footer">
      <a data-url="https://lecoder.gitee.io/study-excel/excel-forecast-ets-function/" data-id="clatcwgr301bmxcq6fxe622ya" class="article-share-link">Share</a>
      
      
    </footer>
  </div>
  
</article>


  
    <article id="post-excel-forecast-ets-confint-function" class="article article-type-post" itemscope itemprop="blogPost">
  <div class="article-meta">
    <a href="/study-excel/excel-forecast-ets-confint-function/" class="article-date">
  <time datetime="2022-11-23T08:00:51.206Z" itemprop="datePublished">2022-11-23</time>
</a>
    
  <div class="article-category">
    <a class="article-category-link" href="/study-excel/categories/%E5%87%BD%E6%95%B0/">函数</a>
  </div>

  </div>
  <div class="article-inner">
    
    
      <header class="article-header">
        
  
    <h1 itemprop="name">
      <a class="article-title" href="/study-excel/excel-forecast-ets-confint-function/">Excel FORECAST.ETS.CONFINT 函数</a>
    </h1>
  

      </header>
    
    <div class="article-entry" itemprop="articleBody">
      
        <p>FORECAST.ETS.CONFINT 函数计算使用 FORECAST.ETS 函数预测的值的置信区间。</p>
<h2 id="适用版本"><a href="#适用版本" class="headerlink" title="适用版本"></a>适用版本</h2><p>Excel 2016+</p>
<h2 id="说明"><a href="#说明" class="headerlink" title="说明"></a>说明</h2><p>FORECAST.ETS.CONFINT 函数计算使用 FORECAST.ETS 函数预测的值的置信区间。</p>
<h2 id="返回值"><a href="#返回值" class="headerlink" title="返回值"></a>返回值</h2><p>置信区间</p>
<h2 id="语法"><a href="#语法" class="headerlink" title="语法"></a>语法</h2><figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=FORECAST.ETS.CONFINT( target_date, values, timeline,[confidence_level], [seasonality], [data completion], [aggregation] )</span><br><span class="line">=FORECAST.ETS.CONFINT( 目标值日期, 历史值, 历史日期, [置信度],[季节性], [遗漏数据补充方式], [相同数据计算方式] )</span><br></pre></td></tr></table></figure>

<h2 id="参数"><a href="#参数" class="headerlink" title="参数"></a>参数</h2><ul>
<li>Target_date（必须）：一个需要预测与之对应的值的目标日期（或时间）。</li>
<li>Values （必须）：一组根据其预测未来值的历史值。</li>
<li>Timeline（必须）：与历史值相对应的一组日期（或时间）系列。<ul>
<li>历史日期（或时间）系列的长度必须与历史值一致；</li>
<li>系列中，每一个历史日期（或时间）之间的间隔必须相同；</li>
<li>系列中，历史日期（或时间）顺序可以是随机的。</li>
</ul>
</li>
<li>Confidence_level（必须）：置信区间的置信度，其值在0-1之间的一个数字。<ul>
<li>如果省略，默认值为95%。</li>
</ul>
</li>
<li>Seasonality（可选）：指示数据的季节性质的一个参数。<ul>
<li>0：数据无季节性质，使用线性算法预测；</li>
<li>1或省略：自动计算数据的季节性，并使用正整数步长作为季节长度；</li>
<li>≥2并≤8760的正整数：使用该数字作为季节长度。</li>
</ul>
</li>
<li>Data completion（可选）：指示日期（或时间）系列中遗漏数据的补充方式的参数。<ul>
<li>0：遗漏的数据计算为零；</li>
<li>1或省略：遗漏数据两侧数据的平均值作为该遗漏数据的值。</li>
</ul>
</li>
<li>Aggregation（可选）：指示具有相同日期（或时间）的数据的计算方式。<ul>
<li>1或省略：平均值；</li>
<li>2：计数；</li>
<li>3：计算（非空值）；</li>
<li>4：最大值；</li>
<li>5：中位数；</li>
<li>6：最小值；</li>
<li>7：求和。</li>
</ul>
</li>
</ul>
<h2 id="要点"><a href="#要点" class="headerlink" title="要点"></a>要点</h2><p>在一定的置信水平（此函数默认为95%）下，未来指定时间的值根据以下公式确定：</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">未来值 = FORECAST.ETS 函数结果 ± FORECAST.ETS.CONFINT 函数结果</span><br></pre></td></tr></table></figure>

<h2 id="实例"><a href="#实例" class="headerlink" title="实例"></a>实例</h2><p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_125365acfa9c224c82ada45abced2c62.png"></p>
<h2 id="可能出现的错误"><a href="#可能出现的错误" class="headerlink" title="可能出现的错误"></a>可能出现的错误</h2><ul>
<li>#N&#x2F;A!<ul>
<li>如果提供的已知日期（或时间）系列与历史值系列长度不一致时；</li>
</ul>
</li>
<li>#NUM!<ul>
<li>如果提供日期（或时间）系列不具有前后一致的步长时；</li>
<li>如果提供的“置信水平”参数不在0-1范围内；</li>
<li>如果提供的“季节性”参数不在允许的范围内时；</li>
<li>如果提供的“遗漏数据补充方式”参数不等于0或1时；</li>
<li>如果提供的“相同数据计算方式”参数不等于1-7的任意一个数字时；</li>
</ul>
</li>
<li>#VALUE!<ul>
<li>如果提供的“置信水平”、“季节性”、“遗漏数据补充方式”或“相同数据计算方式”中任意一个或多个不是数字时。</li>
</ul>
</li>
</ul>
<h2 id="其他"><a href="#其他" class="headerlink" title="其他"></a>其他</h2><p>更多信息及示例请参考<a target="_blank" rel="noopener" href="https://support.office.com/zh-cn/article/FORECAST-ETS-CONFINT-%E5%87%BD%E6%95%B0-6d4a7557-11fa-4678-9e6a-dbcc31a7c7df?ui=zh-CN&rs=zh-CN&ad=CN">微软Office网站</a>。</p>

      
    </div>
    <footer class="article-footer">
      <a data-url="https://lecoder.gitee.io/study-excel/excel-forecast-ets-confint-function/" data-id="clatcwgr101bkxcq64j2p49cb" class="article-share-link">Share</a>
      
      
    </footer>
  </div>
  
</article>


  
    <article id="post-excel-forecast-ets-seasonality-function" class="article article-type-post" itemscope itemprop="blogPost">
  <div class="article-meta">
    <a href="/study-excel/excel-forecast-ets-seasonality-function/" class="article-date">
  <time datetime="2022-11-23T08:00:51.206Z" itemprop="datePublished">2022-11-23</time>
</a>
    
  <div class="article-category">
    <a class="article-category-link" href="/study-excel/categories/%E5%87%BD%E6%95%B0/">函数</a>
  </div>

  </div>
  <div class="article-inner">
    
    
      <header class="article-header">
        
  
    <h1 itemprop="name">
      <a class="article-title" href="/study-excel/excel-forecast-ets-seasonality-function/">Excel FORECAST.ETS.SEASONALITY 函数</a>
    </h1>
  

      </header>
    
    <div class="article-entry" itemprop="articleBody">
      
        <p>FORECAST.ETS.SEASONALITY 函数返回已知数据季节性规律在时间轴上的长度。</p>
<h2 id="适用版本"><a href="#适用版本" class="headerlink" title="适用版本"></a>适用版本</h2><p>Excel 2016+</p>
<h2 id="说明"><a href="#说明" class="headerlink" title="说明"></a>说明</h2><p>FORECAST.ETS.SEASONALITY 函数返回已知数据季节性规律在时间轴上的长度。该函数返回的季节性规律与FORECAST.ETS函数自动计算的季节性规律相同。</p>
<h2 id="返回值"><a href="#返回值" class="headerlink" title="返回值"></a>返回值</h2><p>季节性规律长度</p>
<h2 id="语法"><a href="#语法" class="headerlink" title="语法"></a>语法</h2><figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=FORECAST.ETS.SEASONALITY( values, timeline, [data completion],[aggregation] )</span><br><span class="line">=FORECAST.ETS.SEASONALITY( 历史值, 历史日期, [遗漏数据补充方式], [相同数据计算方式] )</span><br></pre></td></tr></table></figure>

<h2 id="参数"><a href="#参数" class="headerlink" title="参数"></a>参数</h2><ul>
<li>Values （必须）：一组已知的历史值。</li>
<li>Timeline（必须）：与历史值相对应的一组日期（或时间）系列。<ul>
<li>历史日期（或时间）系列的长度必须与历史值一致；</li>
<li>系列中，每一个历史日期（或时间）之间的间隔必须相同；</li>
<li>系列中，历史日期（或时间）顺序可以是随机的。</li>
</ul>
</li>
<li>Data completion（可选）：指示日期（或时间）系列中遗漏数据的补充方式的参数。<ul>
<li>0：遗漏的数据计算为零；</li>
<li>1或省略：遗漏数据两侧数据的平均值作为该遗漏数据的值。</li>
</ul>
</li>
<li>Aggregation（可选）：指示具有相同日期（或时间）的数据的计算方式。<ul>
<li>1或省略：平均值；</li>
<li>2：计数；</li>
<li>3：计算（非空值）；</li>
<li>4：最大值；</li>
<li>5：中位数；</li>
<li>6：最小值；</li>
<li>7：求和。</li>
</ul>
</li>
</ul>
<h2 id="要点"><a href="#要点" class="headerlink" title="要点"></a>要点</h2><ul>
<li>提供的参数相同时，由FORECAST.ETS.SEASONALITY函数计算的季节性规律与FORECAST.ETS函数自动计算的季节性规律相同。</li>
<li>为了计算季节性规律，需要提供足够多的历史数据。提供的历史数据越多，计算的季节性规律越准确。</li>
</ul>
<h2 id="实例"><a href="#实例" class="headerlink" title="实例"></a>实例</h2><p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_73f96a902144b11ded42d2dbc1ad2430.png"></p>
<h2 id="可能出现的错误"><a href="#可能出现的错误" class="headerlink" title="可能出现的错误"></a>可能出现的错误</h2><ul>
<li>#N&#x2F;A!<ul>
<li>如果提供的已知日期（或时间）系列与历史值系列长度不一致时；</li>
</ul>
</li>
<li>#NUM!<ul>
<li>如果提供日期（或时间）系列不具有前后一致的步长时；</li>
<li>如果提供的“遗漏数据补充方式”参数不等于0或1时；</li>
<li>如果提供的“相同数据计算方式”参数不等于1-7的任意一个数字时；</li>
</ul>
</li>
<li>#VALUE!<ul>
<li>如果提供的“遗漏数据补充方式”或“相同数据计算方式”中任意一个或多个不是数字时。</li>
</ul>
</li>
</ul>
<h2 id="其他"><a href="#其他" class="headerlink" title="其他"></a>其他</h2><p>更多信息及示例请参考<a target="_blank" rel="noopener" href="https://support.office.com/zh-cn/article/FORECAST-ETS-SEASONALITY-%E5%87%BD%E6%95%B0-32a27a3b-d22f-42ce-8c5d-ef3649269f3c?ui=zh-CN&rs=zh-CN&ad=CN">微软Office网站</a>。</p>

      
    </div>
    <footer class="article-footer">
      <a data-url="https://lecoder.gitee.io/study-excel/excel-forecast-ets-seasonality-function/" data-id="clatcwgr401boxcq6groyb2f8" class="article-share-link">Share</a>
      
      
    </footer>
  </div>
  
</article>


  
    <article id="post-excel-forecast-ets-stat-function" class="article article-type-post" itemscope itemprop="blogPost">
  <div class="article-meta">
    <a href="/study-excel/excel-forecast-ets-stat-function/" class="article-date">
  <time datetime="2022-11-23T08:00:51.206Z" itemprop="datePublished">2022-11-23</time>
</a>
    
  <div class="article-category">
    <a class="article-category-link" href="/study-excel/categories/%E5%87%BD%E6%95%B0/">函数</a>
  </div>

  </div>
  <div class="article-inner">
    
    
      <header class="article-header">
        
  
    <h1 itemprop="name">
      <a class="article-title" href="/study-excel/excel-forecast-ets-stat-function/">Excel FORECAST.ETS.STAT 函数</a>
    </h1>
  

      </header>
    
    <div class="article-entry" itemprop="articleBody">
      
        <p>FORECAST.ETS.STAT 函数返回基于时间序列预测的结果的指定统计值。</p>
<h2 id="适用版本"><a href="#适用版本" class="headerlink" title="适用版本"></a>适用版本</h2><p>Excel 2016+</p>
<h2 id="说明"><a href="#说明" class="headerlink" title="说明"></a>说明</h2><p>FORECAST.ETS.STAT 函数返回基于时间序列预测的结果的指定统计值。</p>
<h2 id="返回值"><a href="#返回值" class="headerlink" title="返回值"></a>返回值</h2><p>指定统计值</p>
<h2 id="语法"><a href="#语法" class="headerlink" title="语法"></a>语法</h2><figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=FORECAST.ETS.STAT( values, timeline, statistic_type, [seasonality],[data completion], [aggregation] )</span><br><span class="line">=FORECAST.ETS.STAT(  历史值, 历史日期,  [统计类型], [季节性], [遗漏数据补充方式], [相同数据计算方式] )</span><br></pre></td></tr></table></figure>

<h2 id="参数"><a href="#参数" class="headerlink" title="参数"></a>参数</h2><ul>
<li>Values （必须）：一组历史值。</li>
<li>Timeline（必须）：与历史值相对应的一组日期（或时间）系列。<ul>
<li>历史日期（或时间）系列的长度必须与历史值一致；</li>
<li>系列中，每一个历史日期（或时间）之间的间隔必须相同；</li>
<li>系列中，历史日期（或时间）顺序可以是随机的。</li>
</ul>
</li>
<li>Statistic_type（必须）：一个数字，指示要求统计哪一个统计值。其值必须在1-8之间的整数。<ul>
<li>1：ETS 算法的 Alpha 参数，较高值为最新的数据点提供更多的权重；</li>
<li>2：ETS 算法的 Beta 参数，较高值为最近的趋势提供更多权重；</li>
<li>3：ETS 算法的 Gamma 参数，较高值为最近的季节周期提供更多权重；</li>
<li>4：MASE 指标，平均绝对标度误差指标；</li>
<li>5：SMAPE 指标，对称平均绝对百分比误差指标，基于百分比误差衡量准确性；</li>
<li>6：MAE 指标，绝对平均误差指标，衡量预测与最终结果有多接近；</li>
<li>7：RMSE 指标，均方根误差指标，衡量预测值和观察值之间的差异的一种指标；</li>
<li>8：检测到的步长，在提供的日期（或时间）系列中的检测到的步长。</li>
</ul>
</li>
<li>Seasonality（可选）：指示数据的季节性质的一个参数。<ul>
<li>0：数据无季节性质，使用线性算法预测；</li>
<li>1或省略：自动计算数据的季节性，并使用正整数步长作为季节长度；</li>
<li>≥2并≤8760的正整数：使用该数字作为季节长度。</li>
</ul>
</li>
<li>Data completion（可选）：指示日期（或时间）系列中遗漏数据的补充方式的参数。<ul>
<li>0：遗漏的数据计算为零；</li>
<li>1或省略：遗漏数据两侧数据的平均值作为该遗漏数据的值。</li>
</ul>
</li>
<li>Aggregation（可选）：指示具有相同日期（或时间）的数据的计算方式。<ul>
<li>1或省略：平均值；</li>
<li>2：计数；</li>
<li>3：计算（非空值）；</li>
<li>4：最大值；</li>
<li>5：中位数；</li>
<li>6：最小值；</li>
<li>7：求和。</li>
</ul>
</li>
</ul>
<h2 id="实例"><a href="#实例" class="headerlink" title="实例"></a>实例</h2><p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_697ba743d7f5a22189ad41b64fece568.png"></p>
<h2 id="可能出现的错误"><a href="#可能出现的错误" class="headerlink" title="可能出现的错误"></a>可能出现的错误</h2><ul>
<li>#N&#x2F;A!<ul>
<li>如果提供的已知日期（或时间）系列与历史值系列长度不一致时；</li>
</ul>
</li>
<li>#NUM!<ul>
<li>如果提供日期（或时间）系列不具有前后一致的步长时；</li>
<li>如果提供的“统计类型”参数不在1-8范围内；</li>
<li>如果提供的“季节性”参数不在允许的范围内时；</li>
<li>如果提供的“遗漏数据补充方式”参数不等于0或1时；</li>
<li>如果提供的“相同数据计算方式”参数不等于1-7的任意一个数字时；</li>
</ul>
</li>
<li>#VALUE!<ul>
<li>如果提供的“统计类型”、“季节性”、“遗漏数据补充方式”或“相同数据计算方式”中任意一个或多个不是数字时。</li>
</ul>
</li>
</ul>
<h2 id="其他"><a href="#其他" class="headerlink" title="其他"></a>其他</h2><p>更多信息及示例请参考<a target="_blank" rel="noopener" href="https://support.office.com/zh-cn/article/FORECAST-ETS-STAT-%E5%87%BD%E6%95%B0-60f2ae14-d0cf-465e-9736-625ccaaa60b4?ui=zh-CN&rs=zh-CN&ad=CN">微软Office网站</a>。</p>

      
    </div>
    <footer class="article-footer">
      <a data-url="https://lecoder.gitee.io/study-excel/excel-forecast-ets-stat-function/" data-id="clatcwgr601bqxcq640534v26" class="article-share-link">Share</a>
      
      
    </footer>
  </div>
  
</article>


  


  <nav id="page-nav">
    
    <a class="extend prev" rel="prev" href="/study-excel/page/24/">&amp;laquo; 上一页</a><a class="page-number" href="/study-excel/">1</a><span class="space">&hellip;</span><a class="page-number" href="/study-excel/page/23/">23</a><a class="page-number" href="/study-excel/page/24/">24</a><span class="page-number current">25</span><a class="page-number" href="/study-excel/page/26/">26</a><a class="page-number" href="/study-excel/page/27/">27</a><span class="space">&hellip;</span><a class="page-number" href="/study-excel/page/94/">94</a><a class="extend next" rel="next" href="/study-excel/page/26/">下一页 &amp;raquo;</a>
  </nav>

</section>
        
          <aside id="sidebar">
  
    
  <div class="widget-wrap">
    <h3 class="widget-title">分类</h3>
    <div class="widget">
      <ul class="category-list"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/VBA/">VBA</a></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%85%AC%E5%BC%8F/">公式</a></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%87%BD%E6%95%B0/">函数</a></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%87%BD%E6%95%B0%E4%B8%8E%E5%85%AC%E5%BC%8F%E5%9F%BA%E7%A1%80/">函数与公式基础</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%87%BD%E6%95%B0%E4%B8%8E%E5%85%AC%E5%BC%8F%E5%9F%BA%E7%A1%80/%E5%9F%BA%E7%A1%80/">基础</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%87%BD%E6%95%B0%E4%B8%8E%E5%85%AC%E5%BC%8F%E5%9F%BA%E7%A1%80/%E5%9F%BA%E7%A1%80/%E5%85%AC%E5%BC%8F%E5%9F%BA%E7%A1%80/">公式基础</a></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%87%BD%E6%95%B0%E4%B8%8E%E5%85%AC%E5%BC%8F%E5%9F%BA%E7%A1%80/%E5%9F%BA%E7%A1%80/%E5%85%AC%E5%BC%8F%E9%94%99%E8%AF%AF/">公式错误</a></li></ul></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%8A%9F%E8%83%BD/">功能</a></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%8A%9F%E8%83%BD%E5%8C%BA/">功能区</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%8A%9F%E8%83%BD%E5%8C%BA/%E5%9F%BA%E7%A1%80/">基础</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%8A%9F%E8%83%BD%E5%8C%BA/%E5%9F%BA%E7%A1%80/%E5%85%AC%E5%BC%8F/">公式</a></li></ul></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%8D%95%E5%85%83%E6%A0%BC%E5%BC%95%E7%94%A8/">单元格引用</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%8D%95%E5%85%83%E6%A0%BC%E5%BC%95%E7%94%A8/%E5%9F%BA%E7%A1%80/">基础</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%8D%95%E5%85%83%E6%A0%BC%E5%BC%95%E7%94%A8/%E5%9F%BA%E7%A1%80/%E5%87%BD%E6%95%B0%E4%B8%8E%E5%85%AC%E5%BC%8F%E5%9F%BA%E7%A1%80/">函数与公式基础</a></li></ul></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E6%9C%AC%E6%A6%82%E5%BF%B5/">基本概念</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E6%9C%AC%E6%A6%82%E5%BF%B5/%E5%9F%BA%E7%A1%80/">基础</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E6%9C%AC%E6%A6%82%E5%BF%B5/%E5%9F%BA%E7%A1%80/%E4%BD%BF%E7%94%A8-Excel/">使用 Excel</a></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E6%9C%AC%E6%A6%82%E5%BF%B5/%E5%9F%BA%E7%A1%80/%E5%87%BD%E6%95%B0%E4%B8%8E%E5%85%AC%E5%BC%8F/">函数与公式</a></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E6%9C%AC%E6%A6%82%E5%BF%B5/%E5%9F%BA%E7%A1%80/%E5%8D%95%E5%85%83%E6%A0%BC/">单元格</a></li></ul></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E6%9C%AC%E8%AE%BE%E7%BD%AE/">基本设置</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E6%9C%AC%E8%AE%BE%E7%BD%AE/%E5%9F%BA%E7%A1%80/">基础</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E6%9C%AC%E8%AE%BE%E7%BD%AE/%E5%9F%BA%E7%A1%80/%E4%BF%9D%E5%AD%98%E8%AE%BE%E7%BD%AE/">保存设置</a></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E6%9C%AC%E8%AE%BE%E7%BD%AE/%E5%9F%BA%E7%A1%80/%E5%85%AC%E5%BC%8F%E8%AE%BE%E7%BD%AE/">公式设置</a></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E6%9C%AC%E8%AE%BE%E7%BD%AE/%E5%9F%BA%E7%A1%80/%E5%85%B6%E4%BB%96%E8%AE%BE%E7%BD%AE/">其他设置</a></li></ul></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/">基础</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/">基础操作</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E4%BF%9D%E6%8A%A4/">保护</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%A4%8D%E5%88%B6%E5%85%AC%E5%BC%8F/">复制公式</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%A4%8D%E5%88%B6%E5%85%AC%E5%BC%8F/%E5%87%BD%E6%95%B0%E4%B8%8E%E5%85%AC%E5%BC%8F%E5%9F%BA%E7%A1%80/">函数与公式基础</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%AE%A1%E9%98%85/">审阅</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%AE%A1%E9%98%85/%E5%8A%9F%E8%83%BD%E5%8C%BA/">功能区</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%B7%A5%E4%BD%9C%E7%95%8C%E9%9D%A2/">工作界面</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%B7%A5%E4%BD%9C%E7%95%8C%E9%9D%A2/%E5%9F%BA%E6%9C%AC%E6%A6%82%E5%BF%B5/">基本概念</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%B8%B8%E8%A7%81%E6%9C%AF%E8%AF%AD/">常见术语</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%B8%B8%E8%A7%81%E6%9C%AF%E8%AF%AD/%E5%9F%BA%E6%9C%AC%E6%A6%82%E5%BF%B5/">基本概念</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%B8%B8%E8%A7%84%E8%AE%BE%E7%BD%AE/">常规设置</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%B8%B8%E8%A7%84%E8%AE%BE%E7%BD%AE/%E5%9F%BA%E6%9C%AC%E8%AE%BE%E7%BD%AE/">基本设置</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%BC%80%E5%A7%8B/">开始</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%BC%80%E5%A7%8B/%E5%8A%9F%E8%83%BD%E5%8C%BA/">功能区</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%8F%92%E5%85%A5/">插入</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%8F%92%E5%85%A5/%E5%8A%9F%E8%83%BD%E5%8C%BA/">功能区</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%95%B0%E6%8D%AE/">数据</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%95%B0%E6%8D%AE/%E5%8A%9F%E8%83%BD%E5%8C%BA/">功能区</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%96%B0%E5%A2%9E%E5%8A%9F%E8%83%BD%E5%92%8C%E5%87%BD%E6%95%B0/">新增功能和函数</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%96%B0%E5%A2%9E%E5%8A%9F%E8%83%BD%E5%92%8C%E5%87%BD%E6%95%B0/Excel-2007/">Excel 2007</a></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%96%B0%E5%A2%9E%E5%8A%9F%E8%83%BD%E5%92%8C%E5%87%BD%E6%95%B0/Excel-2010/">Excel 2010</a></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%96%B0%E5%A2%9E%E5%8A%9F%E8%83%BD%E5%92%8C%E5%87%BD%E6%95%B0/Excel-2013/">Excel 2013</a></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%96%B0%E5%A2%9E%E5%8A%9F%E8%83%BD%E5%92%8C%E5%87%BD%E6%95%B0/Excel-2016/">Excel 2016</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%A0%A1%E5%AF%B9%E8%AE%BE%E7%BD%AE/">校对设置</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%A0%A1%E5%AF%B9%E8%AE%BE%E7%BD%AE/%E5%9F%BA%E6%9C%AC%E8%AE%BE%E7%BD%AE/">基本设置</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E7%BC%96%E5%86%99%E5%85%AC%E5%BC%8F/">编写公式</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E7%BC%96%E5%86%99%E5%85%AC%E5%BC%8F/%E5%87%BD%E6%95%B0%E4%B8%8E%E5%85%AC%E5%BC%8F%E5%9F%BA%E7%A1%80/">函数与公式基础</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E7%BC%96%E8%BE%91%E5%85%AC%E5%BC%8F/">编辑公式</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E7%BC%96%E8%BE%91%E5%85%AC%E5%BC%8F/%E5%87%BD%E6%95%B0%E4%B8%8E%E5%85%AC%E5%BC%8F%E5%9F%BA%E7%A1%80/">函数与公式基础</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E8%A7%86%E5%9B%BE/">视图</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E8%A7%86%E5%9B%BE/%E5%8A%9F%E8%83%BD%E5%8C%BA/">功能区</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E9%A1%B5%E9%9D%A2%E5%B8%83%E5%B1%80/">页面布局</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E9%A1%B5%E9%9D%A2%E5%B8%83%E5%B1%80/%E5%8A%9F%E8%83%BD%E5%8C%BA/">功能区</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E9%AB%98%E7%BA%A7%E8%AE%BE%E7%BD%AE/">高级设置</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E9%AB%98%E7%BA%A7%E8%AE%BE%E7%BD%AE/%E5%9F%BA%E6%9C%AC%E8%AE%BE%E7%BD%AE/">基本设置</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E9%BC%A0%E6%A0%87%E6%8C%87%E9%92%88/">鼠标指针</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E9%BC%A0%E6%A0%87%E6%8C%87%E9%92%88/%E5%9F%BA%E6%9C%AC%E6%A6%82%E5%BF%B5/">基本概念</a></li></ul></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/">基础操作</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E5%A4%8D%E5%88%B6%E4%B8%8E%E7%B2%98%E8%B4%B4/">复制与粘贴</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E5%A4%8D%E5%88%B6%E4%B8%8E%E7%B2%98%E8%B4%B4/%E5%9F%BA%E7%A1%80/">基础</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E6%89%93%E5%8D%B0/">打印</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E6%89%93%E5%8D%B0/%E5%9F%BA%E7%A1%80/">基础</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E6%9F%A5%E6%89%BE%E4%B8%8E%E9%80%89%E6%8B%A9/">查找与选择</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E6%9F%A5%E6%89%BE%E4%B8%8E%E9%80%89%E6%8B%A9/%E5%9F%BA%E7%A1%80/">基础</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E7%BC%96%E8%BE%91%E5%8D%95%E5%85%83%E6%A0%BC%E6%A0%BC%E5%BC%8F/">编辑单元格格式</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E7%BC%96%E8%BE%91%E5%8D%95%E5%85%83%E6%A0%BC%E6%A0%BC%E5%BC%8F/%E5%9F%BA%E7%A1%80/">基础</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E7%BC%96%E8%BE%91%E5%B7%A5%E4%BD%9C%E8%A1%A8/">编辑工作表</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E7%BC%96%E8%BE%91%E5%B7%A5%E4%BD%9C%E8%A1%A8/%E5%9F%BA%E7%A1%80/">基础</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E7%BC%96%E8%BE%91%E5%B7%A5%E4%BD%9C%E8%A1%A8%E5%8C%BA%E5%9F%9F/">编辑工作表区域</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E7%BC%96%E8%BE%91%E5%B7%A5%E4%BD%9C%E8%A1%A8%E5%8C%BA%E5%9F%9F/%E5%9F%BA%E7%A1%80/">基础</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E7%BC%96%E8%BE%91%E6%95%B0%E5%AD%97%E6%A0%BC%E5%BC%8F/">编辑数字格式</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E7%BC%96%E8%BE%91%E6%95%B0%E5%AD%97%E6%A0%BC%E5%BC%8F/%E5%9F%BA%E7%A1%80/">基础</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E9%BC%A0%E6%A0%87%E6%93%8D%E4%BD%9C/">鼠标操作</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E9%BC%A0%E6%A0%87%E6%93%8D%E4%BD%9C/%E5%9F%BA%E7%A1%80/">基础</a></li></ul></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%BF%AB%E6%8D%B7%E9%94%AE/">快捷键</a></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E9%97%AE%E9%A2%98/">问题</a></li></ul>
    </div>
  </div>


  
    

  
    
  
    
  <div class="widget-wrap">
    <h3 class="widget-title">归档</h3>
    <div class="widget">
      <ul class="archive-list"><li class="archive-list-item"><a class="archive-list-link" href="/study-excel/archives/2022/11/">十一月 2022</a></li></ul>
    </div>
  </div>


  
    
  <div class="widget-wrap">
    <h3 class="widget-title">最新文章</h3>
    <div class="widget">
      <ul>
        
          <li>
            <a href="/study-excel/excel-coupdaybs-function/">Excel COUPDAYBS 函数</a>
          </li>
        
          <li>
            <a href="/study-excel/excel-coupdays-function/">Excel COUPDAYS 函数</a>
          </li>
        
          <li>
            <a href="/study-excel/excel-coupdaysnc-function/">Excel COUPDAYSNC 函数</a>
          </li>
        
          <li>
            <a href="/study-excel/excel-coupncd-function/">Excel COUPNCD 函数</a>
          </li>
        
          <li>
            <a href="/study-excel/excel-coupnum-function/">Excel COUPNUM 函数</a>
          </li>
        
      </ul>
    </div>
  </div>

  
</aside>
        
      </div>
      <footer id="footer">
  
  <div class="outer">
    <div id="footer-info" class="inner">
      &copy; 2022 lijile<br>
      Powered by <a href="http://hexo.io/" target="_blank">Hexo</a>
    </div>
  </div>
</footer>
    </div>
    <nav id="mobile-nav">
  
    <a href="/study-excel/" class="mobile-nav-link">Home</a>
  
    <a href="/study-excel/archives" class="mobile-nav-link">Archives</a>
  
</nav>
    

<script src="//ajax.googleapis.com/ajax/libs/jquery/2.0.3/jquery.min.js"></script>


  
<link rel="stylesheet" href="/study-excel/fancybox/jquery.fancybox.css">

  
<script src="/study-excel/fancybox/jquery.fancybox.pack.js"></script>




<script src="/study-excel/js/script.js"></script>




  </div>
</body>
</html>